Model Table CASH PLAN DETAILS
Attributes
| Attribute |
Description (where applicable) |
| Acc Currency Amount | Represents the cash flow amount in accounting currency excluding tax |
| Acc Currency Amount With Tax | Represents the cash flow amount in accounting currency including tax |
| Calender Date | Represents the date when the cash flow occur |
| Comments | Represents optional comments made on manual cash flows/cash plan adjustments |
| Dim_Sub_Project_ID | |
| ID | |
| MVT_CREATED_DT | |
| Reference Text | Represents reference information from the cash plan source |
| Rep Currency 1 Amount | |
| Rep Currency 1 Amount With Tax | |
| Rep Currency 2 Amount | |
| Rep Currency 2 Amount With Tax | |
| Rep Currency 3 Amount | |
| Rep Currency 3 Amount With Tax | |
| Row ID | |
| Tag 1 | Represents optional tags on manual cash flows/cash plan adjustments |
| Tag 2 | Represents optional tags on manual cash flows/cash plan adjustments |
| Tag 3 | Represents optional tags on manual cash flows/cash plan adjustments |
| Trans Currency Amount | |
| Trans Currency Amount With Tax | |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| CASH PLAN DETAILS | FACT_CASH_PLAN_DETAIL_TM | FACT_CASH_PLAN_DETAIL_BI | FACT_CASH_PLAN_DETAIL | Data Mart |